Pandas Profiling Report

Dataset statistics

Number of variables	30
Number of observations	3901
Missing cells	50824
Missing cells (%)	43.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	914.4 KiB
Average record size in memory	240.0 B

Variable types

Numeric	18
Categorical	12

Alerts

`Payment Method Requested Code` has constant value "99.0"	Constant
`Company Name` has a high cardinality: 1196 distinct values	High cardinality
`Address` has a high cardinality: 1176 distinct values	High cardinality
`City` has a high cardinality: 371 distinct values	High cardinality
`State` has a high cardinality: 57 distinct values	High cardinality
`Nif` has a high cardinality: 3901 distinct values	High cardinality
`Unnamed: 0` is highly correlated with `Payment Method Granted` and 3 other fields	High correlation
`Postal Code` is highly correlated with `State`	High correlation
`Credit Limit Requested` is highly correlated with `Payment Method Requested Code`	High correlation
`Credit Limit Granted` is highly correlated with `Commercial Risk Cover Protected` and 7 other fields	High correlation
`Commercial Risk Group Code` is highly correlated with `Credit Limit Granted` and 8 other fields	High correlation
`Classification Decision Code` is highly correlated with `Credit Limit Granted` and 8 other fields	High correlation
`Request Entry Date` is highly correlated with `Unnamed: 0` and 7 other fields	High correlation
`Effective Date` is highly correlated with `Payment Method Granted` and 2 other fields	High correlation
`ClientePadre` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`IDCliente` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`VENTASCLIENTE` is highly correlated with `NArticulos` and 1 other fields	High correlation
`MBAvg` is highly correlated with `MBMin`	High correlation
`MBMax` is highly correlated with `PrecMedArticulo`	High correlation
`MBMin` is highly correlated with `MBAvg`	High correlation
`NArticulos` is highly correlated with `VENTASCLIENTE` and 1 other fields	High correlation
`NContratos` is highly correlated with `VENTASCLIENTE` and 1 other fields	High correlation
`PrecMedArticulo` is highly correlated with `MBMax`	High correlation
`DifCPrevCReal` is highly correlated with `Payment Method Requested Code`	High correlation
`State` is highly correlated with `Postal Code`	High correlation
`Payment Method Requested Code` is highly correlated with `Payment Method Granted` and 6 other fields	High correlation
`Commercial Risk Cover Protected` is highly correlated with `Credit Limit Granted` and 7 other fields	High correlation
`Payment Method Granted` is highly correlated with `Unnamed: 0` and 12 other fields	High correlation
`Payment Terms Granted` is highly correlated with `Credit Limit Granted` and 7 other fields	High correlation
`Status Code` is highly correlated with `Credit Limit Granted` and 7 other fields	High correlation
`Status` is highly correlated with `Credit Limit Granted` and 7 other fields	High correlation
`Classification Decision` is highly correlated with `Credit Limit Granted` and 9 other fields	High correlation
`Company Name` has 2705 (69.3%) missing values	Missing
`Address` has 2722 (69.8%) missing values	Missing
`City` has 2726 (69.9%) missing values	Missing
`State` has 2714 (69.6%) missing values	Missing
`Postal Code` has 2707 (69.4%) missing values	Missing
`Credit Limit Requested` has 2705 (69.3%) missing values	Missing
`Payment Method Requested Code` has 2705 (69.3%) missing values	Missing
`Credit Limit Granted` has 2705 (69.3%) missing values	Missing
`Commercial Risk Cover Protected` has 2705 (69.3%) missing values	Missing
`Commercial Risk Group Code` has 2705 (69.3%) missing values	Missing
`Payment Method Granted` has 2705 (69.3%) missing values	Missing
`Payment Terms Granted` has 2705 (69.3%) missing values	Missing
`Status Code` has 2705 (69.3%) missing values	Missing
`Status` has 2705 (69.3%) missing values	Missing
`Classification Decision Code` has 2705 (69.3%) missing values	Missing
`Classification Decision` has 2839 (72.8%) missing values	Missing
`Request Entry Date` has 2705 (69.3%) missing values	Missing
`Effective Date` has 2705 (69.3%) missing values	Missing
`DifCPrevCReal` has 1951 (50.0%) missing values	Missing
`MBMax` is highly skewed (γ1 = -32.60607807)	Skewed
`DifCPrevCReal` is highly skewed (γ1 = 41.11657782)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Company Name` is uniformly distributed	Uniform
`Address` is uniformly distributed	Uniform
`Nif` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`Nif` has unique values	Unique
`ClientePadre` has unique values	Unique
`IDCliente` has unique values	Unique
`Credit Limit Granted` has 626 (16.0%) zeros	Zeros
`Commercial Risk Group Code` has 676 (17.3%) zeros	Zeros
`Classification Decision Code` has 134 (3.4%) zeros	Zeros
`VENTASCLIENTE` has 52 (1.3%) zeros	Zeros
`MBMin` has 170 (4.4%) zeros	Zeros
`PrecMedArticulo` has 52 (1.3%) zeros	Zeros
`DifCPrevCReal` has 231 (5.9%) zeros	Zeros

Reproduction

Analysis started	2022-10-30 09:47:37.407737
Analysis finished	2022-10-30 09:48:47.630812
Duration	1 minute and 10.22 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	3901
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1950

Minimum	0
Maximum	3900
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	0
5-th percentile	195
Q1	975
median	1950
Q3	2925
95-th percentile	3705
Maximum	3900
Range	3900
Interquartile range (IQR)	1950

Descriptive statistics

Standard deviation	1126.266028
Coefficient of variation (CV)	0.5775723222
Kurtosis	-1.2
Mean	1950
Median Absolute Deviation (MAD)	975
Skewness	0
Sum	7606950
Variance	1268475.167
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2621	1	< 0.1%
2593	1	< 0.1%
2594	1	< 0.1%
2595	1	< 0.1%
2596	1	< 0.1%
2597	1	< 0.1%
2598	1	< 0.1%
2599	1	< 0.1%
2600	1	< 0.1%
Other values (3891)	3891	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
3900	1	< 0.1%
3899	1	< 0.1%
3898	1	< 0.1%
3897	1	< 0.1%
3896	1	< 0.1%
3895	1	< 0.1%
3894	1	< 0.1%
3893	1	< 0.1%
3892	1	< 0.1%
3891	1	< 0.1%

Company Name
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	1196
Distinct (%)	100.0%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

ARNELA DISEÃ O, S.L.	1
VILLAMAR CRESPO SL	1
CONSTRUCCIONES OREGA SL	1
DISTRIBUCIONES FROIZ SA	1
C. Y P. LOS OBELISCOS S.L.	1
Other values (1191)	1191

Length

Max length	100
Median length	55
Mean length	26.98076923
Min length	4

Characters and Unicode

Total characters	32269
Distinct characters	54
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1196 ?
Unique (%)	100.0%

Sample

1st row	INDUSTRIAS CANDIDO HERMIDA SL
2nd row	ESTRUCTURAS DE HORMIGON Y CONSTRUCCIONES ALPA SL
3rd row	HIJOS JOSE LOSADA CANCELO SA
4th row	CAMUYDE S.L.
5th row	GABADI SL

Common Values

Value	Count	Frequency (%)
ARNELA DISEÃ O, S.L.	1	< 0.1%
VILLAMAR CRESPO SL	1	< 0.1%
CONSTRUCCIONES OREGA SL	1	< 0.1%
DISTRIBUCIONES FROIZ SA	1	< 0.1%
C. Y P. LOS OBELISCOS S.L.	1	< 0.1%
FACTUM INVERSIONES Y PROYECTOS SL.	1	< 0.1%
HIJOS DE VALEIRAS Y ALONSO SOCIEDAD LIMITADA.	1	< 0.1%
TECBETON CONSTRUCCIONES S.L.	1	< 0.1%
RE-CORTA, DEMOLICION TECNICA, SL.	1	< 0.1%
SERFONOR MEDIOAMBIENTE SOCIEDAD LIMITADA.	1	< 0.1%
Other values (1186)	1186	30.4%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sl	532	11.2%
s.l	262	5.5%
y	205	4.3%
sa	142	3.0%
de	136	2.9%
sociedad	115	2.4%
construcciones	105	2.2%
limitada	104	2.2%
servicios	56	1.2%
obras	51	1.1%
Other values (1881)	3045	64.1%

Most occurring characters

Value	Count	Frequency (%)
	3567	11.1%
S	3173	9.8%
A	3132	9.7%
E	2550	7.9%
I	2372	7.4%
O	2323	7.2%
L	2009	6.2%
R	1931	6.0%
C	1746	5.4%
N	1618	5.0%
Other values (44)	7848	24.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	27316	84.7%
Space Separator	3567	11.1%
Other Punctuation	1222	3.8%
Decimal Number	139	0.4%
Dash Punctuation	15	< 0.1%
Modifier Symbol	3	< 0.1%
Lowercase Letter	3	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	3173	11.6%
A	3132	11.5%
E	2550	9.3%
I	2372	8.7%
O	2323	8.5%
L	2009	7.4%
R	1931	7.1%
C	1746	6.4%
N	1618	5.9%
T	1327	4.9%
Other values (20)	5135	18.8%

Decimal Number

Value	Count	Frequency (%)
0	36	25.9%
2	32	23.0%
1	23	16.5%
8	9	6.5%
5	9	6.5%
9	7	5.0%
6	7	5.0%
7	7	5.0%
4	5	3.6%
3	4	2.9%

Other Punctuation

Value	Count	Frequency (%)
.	1046	85.6%
,	164	13.4%
&	7	0.6%
?	2	0.2%
*	1	0.1%
/	1	0.1%
#	1	0.1%

Lowercase Letter

Value	Count	Frequency (%)
ó	2	66.7%
ñ	1	33.3%

Space Separator

Value	Count	Frequency (%)
	3567	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	15	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	3	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27319	84.7%
Common	4950	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	3173	11.6%
A	3132	11.5%
E	2550	9.3%
I	2372	8.7%
O	2323	8.5%
L	2009	7.4%
R	1931	7.1%
C	1746	6.4%
N	1618	5.9%
T	1327	4.9%
Other values (22)	5138	18.8%

Common

Value	Count	Frequency (%)
	3567	72.1%
.	1046	21.1%
,	164	3.3%
0	36	0.7%
2	32	0.6%
1	23	0.5%
-	15	0.3%
8	9	0.2%
5	9	0.2%
9	7	0.1%
Other values (12)	42	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32217	99.8%
None	52	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3567	11.1%
S	3173	9.8%
A	3132	9.7%
E	2550	7.9%
I	2372	7.4%
O	2323	7.2%
L	2009	6.2%
R	1931	6.0%
C	1746	5.4%
N	1618	5.0%
Other values (38)	7796	24.2%

None

Value	Count	Frequency (%)
Ñ	28	53.8%
Ã	18	34.6%
Â	2	3.8%
ó	2	3.8%
Ó	1	1.9%
ñ	1	1.9%

Address
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	1176
Distinct (%)	99.7%
Missing	2722
Missing (%)	69.8%
Memory size	30.6 KiB

000	3
MUELLE COMERCIAL S/N, 0000	2
ALONSO OJEDA, 18 - BJ	1
ANURIÃ AS 14	1
EMILIA PARDO BAZAN 25	1
Other values (1171)	1171

Length

Max length	55
Median length	42
Mean length	23.98473282
Min length	1

Characters and Unicode

Total characters	28278
Distinct characters	71
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1174 ?
Unique (%)	99.6%

Sample

1st row	O CALVARIO S/N
2nd row	VILLA SOLEDAD 2
3rd row	PERBES 35
4th row	CTRA CEDEIRA KM ,
5th row	O ESPIÑO

Common Values

Value	Count	Frequency (%)
000	3	0.1%
MUELLE COMERCIAL S/N, 0000	2	0.1%
ALONSO OJEDA, 18 - BJ	1	< 0.1%
ANURIÃ AS 14	1	< 0.1%
EMILIA PARDO BAZAN 25	1	< 0.1%
LOURIDO 15	1	< 0.1%
FUEROS DE LEON , 00	1	< 0.1%
PRINCIPE, 43 - PISO 1 C	1	< 0.1%
CURROS ENRIQUEZ, 29 - BJ	1	< 0.1%
CANTARRANA, 13 - ENT	1	< 0.1%
Other values (1166)	1166	29.9%
(Missing)	2722	69.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	356	6.7%
de	244	4.6%
1	109	2.0%
piso	79	1.5%
2	77	1.4%
3	72	1.3%
a	71	1.3%
bj	69	1.3%
s/n	68	1.3%
la	58	1.1%
Other values (1708)	4131	77.4%

Most occurring characters

Value	Count	Frequency (%)
	5921	20.9%
A	2845	10.1%
E	1743	6.2%
O	1646	5.8%
R	1532	5.4%
I	1274	4.5%
L	1273	4.5%
N	1151	4.1%
S	1046	3.7%
D	934	3.3%
Other values (61)	8913	31.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18415	65.1%
Space Separator	5921	20.9%
Decimal Number	2319	8.2%
Other Punctuation	853	3.0%
Dash Punctuation	357	1.3%
Open Punctuation	151	0.5%
Close Punctuation	149	0.5%
Other Letter	74	0.3%
Lowercase Letter	39	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2845	15.4%
E	1743	9.5%
O	1646	8.9%
R	1532	8.3%
I	1274	6.9%
L	1273	6.9%
N	1151	6.3%
S	1046	5.7%
D	934	5.1%
C	831	4.5%
Other values (23)	4140	22.5%

Lowercase Letter

Value	Count	Frequency (%)
o	6	15.4%
a	4	10.3%
e	3	7.7%
c	3	7.7%
r	3	7.7%
í	2	5.1%
m	2	5.1%
ñ	2	5.1%
d	2	5.1%
i	2	5.1%
Other values (7)	10	25.6%

Decimal Number

Value	Count	Frequency (%)
1	478	20.6%
0	385	16.6%
2	343	14.8%
3	275	11.9%
5	186	8.0%
4	164	7.1%
6	163	7.0%
8	124	5.3%
7	121	5.2%
9	80	3.4%

Other Punctuation

Value	Count	Frequency (%)
,	535	62.7%
.	179	21.0%
/	134	15.7%
?	5	0.6%

Open Punctuation

Value	Count	Frequency (%)
(	150	99.3%
{	1	0.7%

Other Letter

Value	Count	Frequency (%)
º	71	95.9%
ª	3	4.1%

Space Separator

Value	Count	Frequency (%)
	5921	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	357	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	149	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18528	65.5%
Common	9750	34.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2845	15.4%
E	1743	9.4%
O	1646	8.9%
R	1532	8.3%
I	1274	6.9%
L	1273	6.9%
N	1151	6.2%
S	1046	5.6%
D	934	5.0%
C	831	4.5%
Other values (42)	4253	23.0%

Common

Value	Count	Frequency (%)
	5921	60.7%
,	535	5.5%
1	478	4.9%
0	385	3.9%
-	357	3.7%
2	343	3.5%
3	275	2.8%
5	186	1.9%
.	179	1.8%
4	164	1.7%
Other values (9)	927	9.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28124	99.5%
None	154	0.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5921	21.1%
A	2845	10.1%
E	1743	6.2%
O	1646	5.9%
R	1532	5.4%
I	1274	4.5%
L	1273	4.5%
N	1151	4.1%
S	1046	3.7%
D	934	3.3%
Other values (47)	8759	31.1%

None

Value	Count	Frequency (%)
º	71	46.1%
Ã	31	20.1%
Ñ	26	16.9%
Â	6	3.9%
Ó	5	3.2%
ª	3	1.9%
í	2	1.3%
ñ	2	1.3%
é	2	1.3%
á	2	1.3%
Other values (4)	4	2.6%

City
Categorical

HIGH CARDINALITY
MISSING

Distinct	371
Distinct (%)	31.6%
Missing	2726
Missing (%)	69.9%
Memory size	30.6 KiB

PONFERRADA	85
FERROL	70
NARON	64
MADRID	57
A CORUÃ A	36
Other values (366)	863

Length

Max length	30
Median length	26
Mean length	8.77106383
Min length	1

Characters and Unicode

Total characters	10306
Distinct characters	56
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	253 ?
Unique (%)	21.5%

Sample

1st row	VALDOVIEO
2nd row	EL FERROL
3rd row	EL FERROL
4th row	NARON
5th row	FERROL

Common Values

Value	Count	Frequency (%)
PONFERRADA	85	2.2%
FERROL	70	1.8%
NARON	64	1.6%
MADRID	57	1.5%
A CORUÃ A	36	0.9%
VIGO	28	0.7%
ARTEIXO	23	0.6%
VIVEIRO	23	0.6%
LUGO	22	0.6%
LA CORUÑA	20	0.5%
Other values (361)	747	19.1%
(Missing)	2726	69.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	139	8.0%
ponferrada	86	4.9%
de	83	4.8%
ferrol	81	4.6%
naron	64	3.7%
madrid	59	3.4%
coruña	50	2.9%
la	41	2.4%
coruã	40	2.3%
vigo	28	1.6%
Other values (409)	1073	61.5%

Most occurring characters

Value	Count	Frequency (%)
A	1514	14.7%
R	1169	11.3%
O	1088	10.6%
E	956	9.3%
L	598	5.8%
N	581	5.6%
	577	5.6%
D	543	5.3%
I	499	4.8%
C	395	3.8%
Other values (46)	2386	23.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9655	93.7%
Space Separator	577	5.6%
Dash Punctuation	19	0.2%
Lowercase Letter	18	0.2%
Other Punctuation	13	0.1%
Decimal Number	13	0.1%
Open Punctuation	6	0.1%
Close Punctuation	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1514	15.7%
R	1169	12.1%
O	1088	11.3%
E	956	9.9%
L	598	6.2%
N	581	6.0%
D	543	5.6%
I	499	5.2%
C	395	4.1%
S	350	3.6%
Other values (21)	1962	20.3%

Lowercase Letter

Value	Count	Frequency (%)
ñ	6	33.3%
a	3	16.7%
l	2	11.1%
â	1	5.6%
u	1	5.6%
r	1	5.6%
o	1	5.6%
e	1	5.6%
v	1	5.6%
i	1	5.6%

Decimal Number

Value	Count	Frequency (%)
0	3	23.1%
5	3	23.1%
2	2	15.4%
1	2	15.4%
4	1	7.7%
7	1	7.7%
3	1	7.7%

Other Punctuation

Value	Count	Frequency (%)
?	5	38.5%
/	4	30.8%
,	2	15.4%
.	2	15.4%

Space Separator

Value	Count	Frequency (%)
	577	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	19	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	6	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9673	93.9%
Common	633	6.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1514	15.7%
R	1169	12.1%
O	1088	11.2%
E	956	9.9%
L	598	6.2%
N	581	6.0%
D	543	5.6%
I	499	5.2%
C	395	4.1%
S	350	3.6%
Other values (31)	1980	20.5%

Common

Value	Count	Frequency (%)
	577	91.2%
-	19	3.0%
(	6	0.9%
?	5	0.8%
)	5	0.8%
/	4	0.6%
0	3	0.5%
5	3	0.5%
2	2	0.3%
1	2	0.3%
Other values (5)	7	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10172	98.7%
None	134	1.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1514	14.9%
R	1169	11.5%
O	1088	10.7%
E	956	9.4%
L	598	5.9%
N	581	5.7%
	577	5.7%
D	543	5.3%
I	499	4.9%
C	395	3.9%
Other values (38)	2252	22.1%

None

Value	Count	Frequency (%)
Ã	60	44.8%
Ñ	59	44.0%
ñ	6	4.5%
Â	4	3.0%
Ü	2	1.5%
â	1	0.7%
Ó	1	0.7%
È	1	0.7%

State
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	57
Distinct (%)	4.8%
Missing	2714
Missing (%)	69.6%
Memory size	30.6 KiB

LA CORUñA	435
LEON	180
LUGO	121
MADRID	89
PONTEVEDRA	76
Other values (52)	286

Length

Max length	12
Median length	11
Mean length	7.291491154
Min length	4

Characters and Unicode

Total characters	8655
Distinct characters	40
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	1.8%

Sample

1st row	LA CORUÑA
2nd row	LA CORU A
3rd row	LA CORU A
4th row	LA CORUñA
5th row	LA CORUÑA

Common Values

Value	Count	Frequency (%)
LA CORUñA	435	11.2%
LEON	180	4.6%
LUGO	121	3.1%
MADRID	89	2.3%
PONTEVEDRA	76	1.9%
LA CORUÑA	57	1.5%
ORENSE	39	1.0%
ASTURIAS	27	0.7%
LA CORU A	18	0.5%
BARCELONA	17	0.4%
Other values (47)	128	3.3%
(Missing)	2714	69.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
la	515	29.7%
coruña	505	29.1%
leon	180	10.4%
lugo	122	7.0%
madrid	91	5.3%
pontevedra	76	4.4%
orense	39	2.3%
asturias	28	1.6%
a	27	1.6%
coru	18	1.0%
Other values (41)	132	7.6%

Most occurring characters

Value	Count	Frequency (%)
A	1498	17.3%
O	991	11.5%
L	904	10.4%
R	824	9.5%
U	695	8.0%
C	588	6.8%
	547	6.3%
E	467	5.4%
ñ	440	5.1%
N	345	4.0%
Other values (30)	1356	15.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7624	88.1%
Space Separator	547	6.3%
Lowercase Letter	484	5.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1498	19.6%
O	991	13.0%
L	904	11.9%
R	824	10.8%
U	695	9.1%
C	588	7.7%
E	467	6.1%
N	345	4.5%
D	283	3.7%
I	188	2.5%
Other values (14)	841	11.0%

Lowercase Letter

Value	Count	Frequency (%)
ñ	440	90.9%
a	10	2.1%
r	6	1.2%
u	5	1.0%
d	4	0.8%
i	4	0.8%
o	4	0.8%
e	2	0.4%
s	2	0.4%
l	2	0.4%
Other values (5)	5	1.0%

Space Separator

Value	Count	Frequency (%)
	547	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8108	93.7%
Common	547	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1498	18.5%
O	991	12.2%
L	904	11.1%
R	824	10.2%
U	695	8.6%
C	588	7.3%
E	467	5.8%
ñ	440	5.4%
N	345	4.3%
D	283	3.5%
Other values (29)	1073	13.2%

Common

Value	Count	Frequency (%)
	547	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8147	94.1%
None	508	5.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1498	18.4%
O	991	12.2%
L	904	11.1%
R	824	10.1%
U	695	8.5%
C	588	7.2%
	547	6.7%
E	467	5.7%
N	345	4.2%
D	283	3.5%
Other values (26)	1005	12.3%

None

Value	Count	Frequency (%)
ñ	440	86.6%
Ñ	66	13.0%
ó	1	0.2%
Ó	1	0.2%

Postal Code
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	468
Distinct (%)	39.2%
Missing	2707
Missing (%)	69.4%
Infinite	0
Infinite (%)	0.0%
Mean	22777.01508

Minimum	2400
Maximum	50197
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	2400
5-th percentile	15000
Q1	15320
median	24193
Q3	28009
95-th percentile	36810.5
Maximum	50197
Range	47797
Interquartile range (IQR)	12689

Descriptive statistics

Standard deviation	8900.51262
Coefficient of variation (CV)	0.3907672972
Kurtosis	0.1397390441
Mean	22777.01508
Median Absolute Deviation (MAD)	8623
Skewness	0.7268860837
Sum	27195756
Variance	79219124.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24400	44	1.1%
15570	35	0.9%
15000	34	0.9%
27850	29	0.7%
15190	24	0.6%
15008	21	0.5%
15320	18	0.5%
15142	16	0.4%
24402	16	0.4%
15405	15	0.4%
Other values (458)	942	24.1%
(Missing)	2707	69.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2400	1	< 0.1%
2440	1	< 0.1%
3295	1	< 0.1%
3321	1	< 0.1%
3600	1	< 0.1%
3690	1	< 0.1%
3804	1	< 0.1%
4240	1	< 0.1%
4610	2	0.1%
7003	1	< 0.1%

Value	Count	Frequency (%)
50197	1	< 0.1%
50003	1	< 0.1%
49696	1	< 0.1%
48980	1	< 0.1%
48970	1	< 0.1%
48960	2	0.1%
48950	1	< 0.1%
48700	1	< 0.1%
48530	1	< 0.1%
48170	1	< 0.1%

Credit Limit Requested
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	0.5%
Missing	2705
Missing (%)	69.3%
Infinite	0
Infinite (%)	0.0%
Mean	44928.92977

Minimum	10000
Maximum	70000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	10000
5-th percentile	45000
Q1	45000
median	45000
Q3	45000
95-th percentile	45000
Maximum	70000
Range	60000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1775.933729
Coefficient of variation (CV)	0.03952762148
Kurtosis	270.0713326
Mean	44928.92977
Median Absolute Deviation (MAD)	0
Skewness	-11.53372543
Sum	53735000
Variance	3153940.611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
45000	1191	30.5%
70000	1	< 0.1%
20000	1	< 0.1%
25000	1	< 0.1%
15000	1	< 0.1%
10000	1	< 0.1%
(Missing)	2705	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000	1	< 0.1%
15000	1	< 0.1%
20000	1	< 0.1%
25000	1	< 0.1%
45000	1191	30.5%
70000	1	< 0.1%

Value	Count	Frequency (%)
70000	1	< 0.1%
45000	1191	30.5%
25000	1	< 0.1%
20000	1	< 0.1%
15000	1	< 0.1%
10000	1	< 0.1%

Payment Method Requested Code
Categorical

CONSTANT
HIGH CORRELATION
MISSING
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

99.0	1196

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	4784
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	99.0
2nd row	99.0
3rd row	99.0
4th row	99.0
5th row	99.0

Common Values

Value	Count	Frequency (%)
99.0	1196	30.7%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
99.0	1196	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	2392	50.0%
.	1196	25.0%
0	1196	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3588	75.0%
Other Punctuation	1196	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	2392	66.7%
0	1196	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	1196	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4784	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	2392	50.0%
.	1196	25.0%
0	1196	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4784	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	2392	50.0%
.	1196	25.0%
0	1196	25.0%

Credit Limit Granted
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	17
Distinct (%)	1.4%
Missing	2705
Missing (%)	69.3%
Infinite	0
Infinite (%)	0.0%
Mean	16740.80268

Minimum	0
Maximum	45000
Zeros	626
Zeros (%)	16.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	45000
95-th percentile	45000
Maximum	45000
Range	45000
Interquartile range (IQR)	45000

Descriptive statistics

Standard deviation	20156.11972
Coefficient of variation (CV)	1.204011547
Kurtosis	-1.541095265
Mean	16740.80268
Median Absolute Deviation (MAD)	0
Skewness	0.5619382697
Sum	20022000
Variance	406269162.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	626	16.0%
45000	370	9.5%
10000	57	1.5%
20000	37	0.9%
25000	19	0.5%
15000	17	0.4%
5000	14	0.4%
8000	10	0.3%
28000	7	0.2%
30000	6	0.2%
Other values (7)	33	0.8%
(Missing)	2705	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	626	16.0%
3000	2	0.1%
5000	14	0.4%
8000	10	0.3%
10000	57	1.5%
12000	5	0.1%
15000	17	0.4%
18000	6	0.2%
20000	37	0.9%
22000	5	0.1%

Value	Count	Frequency (%)
45000	370	9.5%
38000	4	0.1%
35000	6	0.2%
32000	5	0.1%
30000	6	0.2%
28000	7	0.2%
25000	19	0.5%
22000	5	0.1%
20000	37	0.9%
18000	6	0.2%

Commercial Risk Cover Protected
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.3%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

0.0	626
95.0	561
50.0	9

Length

Max length	4
Median length	3
Mean length	3.476588629
Min length	3

Characters and Unicode

Total characters	4158
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	95.0
4th row	0.0
5th row	95.0

Common Values

Value	Count	Frequency (%)
0.0	626	16.0%
95.0	561	14.4%
50.0	9	0.2%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	626	52.3%
95.0	561	46.9%
50.0	9	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	1831	44.0%
.	1196	28.8%
5	570	13.7%
9	561	13.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2962	71.2%
Other Punctuation	1196	28.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1831	61.8%
5	570	19.2%
9	561	18.9%

Other Punctuation

Value	Count	Frequency (%)
.	1196	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4158	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1831	44.0%
.	1196	28.8%
5	570	13.7%
9	561	13.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4158	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1831	44.0%
.	1196	28.8%
5	570	13.7%
9	561	13.5%

Commercial Risk Group Code
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	8
Distinct (%)	0.7%
Missing	2705
Missing (%)	69.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.689799331

Minimum	0
Maximum	7
Zeros	676
Zeros (%)	17.3%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	6
Maximum	7
Range	7
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.207616248
Coefficient of variation (CV)	1.306436929
Kurtosis	-0.8857181646
Mean	1.689799331
Median Absolute Deviation (MAD)	0
Skewness	0.8369343879
Sum	2021
Variance	4.873569499
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	676	17.3%
5	162	4.2%
4	91	2.3%
2	72	1.8%
3	68	1.7%
1	56	1.4%
6	54	1.4%
7	17	0.4%
(Missing)	2705	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	676	17.3%
1	56	1.4%
2	72	1.8%
3	68	1.7%
4	91	2.3%
5	162	4.2%
6	54	1.4%
7	17	0.4%

Value	Count	Frequency (%)
7	17	0.4%
6	54	1.4%
5	162	4.2%
4	91	2.3%
3	68	1.7%
2	72	1.8%
1	56	1.4%
0	676	17.3%

Payment Method Granted
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	0.2%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

0.0	626
99.0	570

Length

Max length	4
Median length	3
Mean length	3.476588629
Min length	3

Characters and Unicode

Total characters	4158
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	99.0
4th row	0.0
5th row	99.0

Common Values

Value	Count	Frequency (%)
0.0	626	16.0%
99.0	570	14.6%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	626	52.3%
99.0	570	47.7%

Most occurring characters

Value	Count	Frequency (%)
0	1822	43.8%
.	1196	28.8%
9	1140	27.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2962	71.2%
Other Punctuation	1196	28.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1822	61.5%
9	1140	38.5%

Other Punctuation

Value	Count	Frequency (%)
.	1196	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4158	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1822	43.8%
.	1196	28.8%
9	1140	27.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4158	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1822	43.8%
.	1196	28.8%
9	1140	27.4%

Payment Terms Granted
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.3%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

0.0	626
180.0	569
150.0	1

Length

Max length	5
Median length	3
Mean length	3.953177258
Min length	3

Characters and Unicode

Total characters	4728
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	180.0
4th row	0.0
5th row	180.0

Common Values

Value	Count	Frequency (%)
0.0	626	16.0%
180.0	569	14.6%
150.0	1	< 0.1%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	626	52.3%
180.0	569	47.6%
150.0	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	2392	50.6%
.	1196	25.3%
1	570	12.1%
8	569	12.0%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3532	74.7%
Other Punctuation	1196	25.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2392	67.7%
1	570	16.1%
8	569	16.1%
5	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	1196	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4728	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2392	50.6%
.	1196	25.3%
1	570	12.1%
8	569	12.0%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4728	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2392	50.6%
.	1196	25.3%
1	570	12.1%
8	569	12.0%
5	1	< 0.1%

Status Code
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.3%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

2.0	626
66.0	564
8.0	6

Length

Max length	4
Median length	3
Mean length	3.471571906
Min length	3

Characters and Unicode

Total characters	4152
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	66.0
4th row	2.0
5th row	66.0

Common Values

Value	Count	Frequency (%)
2.0	626	16.0%
66.0	564	14.5%
8.0	6	0.2%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2.0	626	52.3%
66.0	564	47.2%
8.0	6	0.5%

Most occurring characters

Value	Count	Frequency (%)
.	1196	28.8%
0	1196	28.8%
6	1128	27.2%
2	626	15.1%
8	6	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2956	71.2%
Other Punctuation	1196	28.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1196	40.5%
6	1128	38.2%
2	626	21.2%
8	6	0.2%

Other Punctuation

Value	Count	Frequency (%)
.	1196	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4152	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	1196	28.8%
0	1196	28.8%
6	1128	27.2%
2	626	15.1%
8	6	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4152	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	1196	28.8%
0	1196	28.8%
6	1128	27.2%
2	626	15.1%
8	6	0.1%

Status
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.3%
Missing	2705
Missing (%)	69.3%
Memory size	30.6 KiB

ANULADA	626
EN VIGOR	564
ANULADA-MANTENIMIENTO	6

Length

Max length	21
Median length	7
Mean length	7.54180602
Min length	7

Characters and Unicode

Total characters	9020
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ANULADA
2nd row	ANULADA
3rd row	EN VIGOR
4th row	ANULADA
5th row	EN VIGOR

Common Values

Value	Count	Frequency (%)
ANULADA	626	16.0%
EN VIGOR	564	14.5%
ANULADA-MANTENIMIENTO	6	0.2%
(Missing)	2705	69.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
anulada	626	35.6%
en	564	32.0%
vigor	564	32.0%
anulada-mantenimiento	6	0.3%

Most occurring characters

Value	Count	Frequency (%)
A	1902	21.1%
N	1214	13.5%
U	632	7.0%
L	632	7.0%
D	632	7.0%
E	576	6.4%
I	576	6.4%
O	570	6.3%
	564	6.3%
V	564	6.3%
Other values (5)	1158	12.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8450	93.7%
Space Separator	564	6.3%
Dash Punctuation	6	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1902	22.5%
N	1214	14.4%
U	632	7.5%
L	632	7.5%
D	632	7.5%
E	576	6.8%
I	576	6.8%
O	570	6.7%
V	564	6.7%
G	564	6.7%
Other values (3)	588	7.0%

Space Separator

Value	Count	Frequency (%)
	564	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8450	93.7%
Common	570	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1902	22.5%
N	1214	14.4%
U	632	7.5%
L	632	7.5%
D	632	7.5%
E	576	6.8%
I	576	6.8%
O	570	6.7%
V	564	6.7%
G	564	6.7%
Other values (3)	588	7.0%

Common

Value	Count	Frequency (%)
	564	98.9%
-	6	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9020	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1902	21.1%
N	1214	13.5%
U	632	7.0%
L	632	7.0%
D	632	7.0%
E	576	6.4%
I	576	6.4%
O	570	6.3%
	564	6.3%
V	564	6.3%
Other values (5)	1158	12.8%

Classification Decision Code
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	22
Distinct (%)	1.8%
Missing	2705
Missing (%)	69.3%
Infinite	0
Infinite (%)	0.0%
Mean	31.73745819

Minimum	0
Maximum	80
Zeros	134
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	23
median	32
Q3	46
95-th percentile	46
Maximum	80
Range	80
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	16.01932833
Coefficient of variation (CV)	0.5047451574
Kurtosis	0.4355984877
Mean	31.73745819
Median Absolute Deviation (MAD)	11
Skewness	-0.1874815949
Sum	37958
Variance	256.6188802
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
46	353	9.0%
23	185	4.7%
32	144	3.7%
0	134	3.4%
35	99	2.5%
29	67	1.7%
21	65	1.7%
30	31	0.8%
65	27	0.7%
33	20	0.5%
Other values (12)	71	1.8%
(Missing)	2705	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	134	3.4%
3	4	0.1%
7	3	0.1%
9	1	< 0.1%
20	12	0.3%
21	65	1.7%
23	185	4.7%
24	1	< 0.1%
25	14	0.4%
26	3	0.1%

Value	Count	Frequency (%)
80	12	0.3%
74	4	0.1%
65	27	0.7%
58	3	0.1%
55	1	< 0.1%
46	353	9.0%
40	13	0.3%
35	99	2.5%
33	20	0.5%
32	144	3.7%

Classification Decision
Categorical

HIGH CORRELATION
MISSING

Distinct	21
Distinct (%)	2.0%
Missing	2839
Missing (%)	72.8%
Memory size	30.6 KiB

SOLICITADO POR EL ASEGURADO	353
DECISION CESCE	185
DIMENSIÓN REDUCIDA	144
PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE	99
PATRIMONIO NETO NEGATIVO	67
Other values (16)	214

Length

Max length	54
Median length	52
Mean length	27.64783427
Min length	14

Characters and Unicode

Total characters	29362
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.3%

Sample

1st row	VOLUMEN DE RIESGO ELEVADO
2nd row	PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE
3rd row	DECISION CESCE
4th row	ANULACIÓN POR VENCIMIENTO DE LA VALIDEZ DEL SUPLEMENTO
5th row	SITUACIÓN FINANCIERA AJUSTADA

Common Values

Value	Count	Frequency (%)
SOLICITADO POR EL ASEGURADO	353	9.0%
DECISION CESCE	185	4.7%
DIMENSIÓN REDUCIDA	144	3.7%
PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE	99	2.5%
PATRIMONIO NETO NEGATIVO	67	1.7%
EXPERIENCIA COMERCIAL NEGATIVA: INCIDENCIAS EN PAGOS	65	1.7%
SITUACIÓN FINANCIERA AJUSTADA	31	0.8%
ANULACIÓN POR VENCIMIENTO DE LA VALIDEZ DEL SUPLEMENTO	27	0.7%
AUSENCIA DE DATOS FINANCIEROS DE LA SOCIEDAD	20	0.5%
GRUPO ECONÓMICO EN SITUACIÓN DELICADA	14	0.4%
Other values (11)	57	1.5%
(Missing)	2839	72.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
el	452	11.3%
por	381	9.5%
asegurado	354	8.8%
solicitado	353	8.8%
decision	185	4.6%
cesce	185	4.6%
en	180	4.5%
reducida	144	3.6%
dimensión	144	3.6%
de	103	2.6%
Other values (56)	1519	38.0%

Most occurring characters

Value	Count	Frequency (%)
I	3330	11.3%
E	3195	10.9%
	2938	10.0%
O	2619	8.9%
A	2380	8.1%
D	2028	6.9%
C	1937	6.6%
S	1808	6.2%
N	1664	5.7%
R	1419	4.8%
Other values (20)	6044	20.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	26341	89.7%
Space Separator	2938	10.0%
Other Punctuation	83	0.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	3330	12.6%
E	3195	12.1%
O	2619	9.9%
A	2380	9.0%
D	2028	7.7%
C	1937	7.4%
S	1808	6.9%
N	1664	6.3%
R	1419	5.4%
L	1302	4.9%
Other values (16)	4659	17.7%

Other Punctuation

Value	Count	Frequency (%)
:	65	78.3%
/	16	19.3%
.	2	2.4%

Space Separator

Value	Count	Frequency (%)
	2938	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	26341	89.7%
Common	3021	10.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	3330	12.6%
E	3195	12.1%
O	2619	9.9%
A	2380	9.0%
D	2028	7.7%
C	1937	7.4%
S	1808	6.9%
N	1664	6.3%
R	1419	5.4%
L	1302	4.9%
Other values (16)	4659	17.7%

Common

Value	Count	Frequency (%)
	2938	97.3%
:	65	2.2%
/	16	0.5%
.	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28890	98.4%
None	472	1.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	3330	11.5%
E	3195	11.1%
	2938	10.2%
O	2619	9.1%
A	2380	8.2%
D	2028	7.0%
C	1937	6.7%
S	1808	6.3%
N	1664	5.8%
R	1419	4.9%
Other values (15)	5572	19.3%

None

Value	Count	Frequency (%)
Ó	258	54.7%
É	99	21.0%
Ú	99	21.0%
Í	13	2.8%
Á	3	0.6%

Request Entry Date
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	380
Distinct (%)	31.8%
Missing	2705
Missing (%)	69.3%
Infinite	0
Infinite (%)	0.0%
Mean	20208125.43

Minimum	20200318
Maximum	20221007
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	20200318
5-th percentile	20200318
Q1	20200608
median	20210219.5
Q3	20211123
95-th percentile	20220806.75
Maximum	20221007
Range	20689
Interquartile range (IQR)	10515

Descriptive statistics

Standard deviation	7954.607502
Coefficient of variation (CV)	0.0003936341117
Kurtosis	-1.285469961
Mean	20208125.43
Median Absolute Deviation (MAD)	9511.5
Skewness	0.4635236596
Sum	2.416891802 × 10¹⁰
Variance	63275780.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20200318	179	4.6%
20200409	46	1.2%
20200805	32	0.8%
20200608	31	0.8%
20200708	29	0.7%
20200907	20	0.5%
20201005	18	0.5%
20200401	18	0.5%
20210420	18	0.5%
20200720	17	0.4%
Other values (370)	788	20.2%
(Missing)	2705	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20200318	179	4.6%
20200327	1	< 0.1%
20200401	18	0.5%
20200408	1	< 0.1%
20200409	46	1.2%
20200413	1	< 0.1%
20200415	1	< 0.1%
20200505	17	0.4%
20200506	2	0.1%
20200512	7	0.2%

Value	Count	Frequency (%)
20221007	1	< 0.1%
20221003	1	< 0.1%
20220929	2	0.1%
20220928	1	< 0.1%
20220927	1	< 0.1%
20220926	2	0.1%
20220923	15	0.4%
20220922	1	< 0.1%
20220920	2	0.1%
20220919	1	< 0.1%

Effective Date
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	244
Distinct (%)	20.4%
Missing	2705
Missing (%)	69.3%
Infinite	0
Infinite (%)	0.0%
Mean	20215230.69

Minimum	20200201
Maximum	20221007
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	20200201
5-th percentile	20200608
Q1	20210702
median	20220228
Q3	20220601
95-th percentile	20220901
Maximum	20221007
Range	20806
Interquartile range (IQR)	9899

Descriptive statistics

Standard deviation	6806.491913
Coefficient of variation (CV)	0.0003367011744
Kurtosis	-0.3580692703
Mean	20215230.69
Median Absolute Deviation (MAD)	573
Skewness	-0.9237217074
Sum	2.417741591 × 10¹⁰
Variance	46328332.17
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20220601	70	1.8%
20220701	62	1.6%
20220801	59	1.5%
20220302	54	1.4%
20220401	51	1.3%
20220501	45	1.2%
20220301	45	1.2%
20210201	41	1.1%
20220101	39	1.0%
20200217	32	0.8%
Other values (234)	698	17.9%
(Missing)	2705	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20200201	9	0.2%
20200217	32	0.8%
20200301	6	0.2%
20200319	1	< 0.1%
20200408	1	< 0.1%
20200415	1	< 0.1%
20200505	1	< 0.1%
20200506	1	< 0.1%
20200515	1	< 0.1%
20200529	2	0.1%

Value	Count	Frequency (%)
20221007	2	0.1%
20221006	1	< 0.1%
20221005	1	< 0.1%
20221004	2	0.1%
20221003	1	< 0.1%
20221002	11	0.3%
20220928	1	< 0.1%
20220924	2	0.1%
20220923	2	0.1%
20220920	1	< 0.1%

Nif
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	3901
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	30.6 KiB

U27869056	1
33821719N	1
32616175J	1
32705980A	1
32725490D	1
Other values (3896)	3896

Length

Max length	13
Median length	9
Mean length	9.004101512
Min length	9

Characters and Unicode

Total characters	35125
Distinct characters	37
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3901 ?
Unique (%)	100.0%

Sample

1st row	U27869056
2nd row	B15057474
3rd row	B15399314
4th row	B15054109
5th row	A15056849

Common Values

Value	Count	Frequency (%)
U27869056	1	< 0.1%
33821719N	1	< 0.1%
32616175J	1	< 0.1%
32705980A	1	< 0.1%
32725490D	1	< 0.1%
35591049K	1	< 0.1%
J32412157	1	< 0.1%
32718189E	1	< 0.1%
71508307L	1	< 0.1%
A08507915	1	< 0.1%
Other values (3891)	3891	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
u27869056	1	< 0.1%
b15119837	1	< 0.1%
g15037070	1	< 0.1%
b15399314	1	< 0.1%
b15054109	1	< 0.1%
a15056849	1	< 0.1%
b15025760	1	< 0.1%
p1503700e	1	< 0.1%
p1505500g	1	< 0.1%
b15225055	1	< 0.1%
Other values (3891)	3891	99.7%

Most occurring characters

Value	Count	Frequency (%)
3	3793	10.8%
2	3660	10.4%
0	3462	9.9%
7	3361	9.6%
6	3079	8.8%
1	3076	8.8%
4	3032	8.6%
5	2923	8.3%
9	2365	6.7%
8	2338	6.7%
Other values (27)	4036	11.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	31089	88.5%
Uppercase Letter	4033	11.5%
Space Separator	2	< 0.1%
Lowercase Letter	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	1320	32.7%
A	302	7.5%
G	169	4.2%
X	143	3.5%
P	142	3.5%
E	140	3.5%
J	125	3.1%
Q	123	3.0%
L	115	2.9%
F	113	2.8%
Other values (15)	1341	33.3%

Decimal Number

Value	Count	Frequency (%)
3	3793	12.2%
2	3660	11.8%
0	3462	11.1%
7	3361	10.8%
6	3079	9.9%
1	3076	9.9%
4	3032	9.8%
5	2923	9.4%
9	2365	7.6%
8	2338	7.5%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Lowercase Letter

Value	Count	Frequency (%)
b	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	31091	88.5%
Latin	4034	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	1320	32.7%
A	302	7.5%
G	169	4.2%
X	143	3.5%
P	142	3.5%
E	140	3.5%
J	125	3.1%
Q	123	3.0%
L	115	2.9%
F	113	2.8%
Other values (16)	1342	33.3%

Common

Value	Count	Frequency (%)
3	3793	12.2%
2	3660	11.8%
0	3462	11.1%
7	3361	10.8%
6	3079	9.9%
1	3076	9.9%
4	3032	9.8%
5	2923	9.4%
9	2365	7.6%
8	2338	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35125	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	3793	10.8%
2	3660	10.4%
0	3462	9.9%
7	3361	9.6%
6	3079	8.8%
1	3076	8.8%
4	3032	8.6%
5	2923	8.3%
9	2365	6.7%
8	2338	6.7%
Other values (27)	4036	11.5%

ClientePadre
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	3901
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3376.734171

Minimum	8
Maximum	6378
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	8
5-th percentile	277
Q1	2169
median	3461
Q3	4864
95-th percentile	6049
Maximum	6378
Range	6370
Interquartile range (IQR)	2695

Descriptive statistics

Standard deviation	1792.120434
Coefficient of variation (CV)	0.530725945
Kurtosis	-0.9967939709
Mean	3376.734171
Median Absolute Deviation (MAD)	1359
Skewness	-0.21295503
Sum	13172640
Variance	3211695.649
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	1	< 0.1%
4426	1	< 0.1%
4381	1	< 0.1%
4384	1	< 0.1%
4386	1	< 0.1%
4388	1	< 0.1%
4390	1	< 0.1%
4391	1	< 0.1%
4392	1	< 0.1%
4393	1	< 0.1%
Other values (3891)	3891	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%

Value	Count	Frequency (%)
6378	1	< 0.1%
6375	1	< 0.1%
6367	1	< 0.1%
6361	1	< 0.1%
6359	1	< 0.1%
6356	1	< 0.1%
6354	1	< 0.1%
6353	1	< 0.1%
6352	1	< 0.1%
6350	1	< 0.1%

IDCliente
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	3901
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33767344.86

Minimum	80002
Maximum	63780002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	80002
5-th percentile	2770007
Q1	21690002
median	34610002
Q3	48640002
95-th percentile	60490002
Maximum	63780002
Range	63700000
Interquartile range (IQR)	26950000

Descriptive statistics

Standard deviation	17921202.89
Coefficient of variation (CV)	0.5307258524
Kurtosis	-0.9967941354
Mean	33767344.86
Median Absolute Deviation (MAD)	13590000
Skewness	-0.2129548645
Sum	1.317264123 × 10¹¹
Variance	3.211695129 × 10¹⁴
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80002	1	< 0.1%
44260002	1	< 0.1%
43810002	1	< 0.1%
43840002	1	< 0.1%
43860002	1	< 0.1%
43880003	1	< 0.1%
43900002	1	< 0.1%
43910002	1	< 0.1%
43920002	1	< 0.1%
43930002	1	< 0.1%
Other values (3891)	3891	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
80002	1	< 0.1%
110007	1	< 0.1%
120003	1	< 0.1%
130030	1	< 0.1%
140010	1	< 0.1%
150003	1	< 0.1%
160011	1	< 0.1%
170004	1	< 0.1%
180003	1	< 0.1%
190002	1	< 0.1%

Value	Count	Frequency (%)
63780002	1	< 0.1%
63750002	1	< 0.1%
63670002	1	< 0.1%
63610002	1	< 0.1%
63590002	1	< 0.1%
63560002	1	< 0.1%
63540002	1	< 0.1%
63530002	1	< 0.1%
63520002	1	< 0.1%
63500002	1	< 0.1%

VENTASCLIENTE
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	2124
Distinct (%)	54.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	536.5136132

Minimum	-904.22
Maximum	32216.492
Zeros	52
Zeros (%)	1.3%
Negative	4
Negative (%)	0.1%
Memory size	30.6 KiB

Quantile statistics

Minimum	-904.22
5-th percentile	12.12
Q1	35.35
median	91.91
Q3	311.76
95-th percentile	2298.9866
Maximum	32216.492
Range	33120.712
Interquartile range (IQR)	276.41

Descriptive statistics

Standard deviation	1816.182784
Coefficient of variation (CV)	3.385156946
Kurtosis	117.999962
Mean	536.5136132
Median Absolute Deviation (MAD)	71.71
Skewness	9.305757657
Sum	2092939.605
Variance	3298519.906
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.4	140	3.6%
35.35	130	3.3%
12.12	74	1.9%
24.24	61	1.6%
29.29	60	1.5%
25.25	58	1.5%
0	52	1.3%
30.3	46	1.2%
18.18	42	1.1%
20.2	41	1.1%
Other values (2114)	3197	82.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-904.22	1	< 0.1%
-545.445	1	< 0.1%
-84.84	1	< 0.1%
-10.53	1	< 0.1%
0	52	1.3%
0.0202	1	< 0.1%
0.606	1	< 0.1%
0.7575	1	< 0.1%
0.808	1	< 0.1%
0.99	1	< 0.1%

Value	Count	Frequency (%)
32216.492	1	< 0.1%
31651.227	1	< 0.1%
29955.642	1	< 0.1%
29217.0733	1	< 0.1%
27892.595	1	< 0.1%
21944.2605	1	< 0.1%
20148.224	1	< 0.1%
19338.4757	1	< 0.1%
17788.4931	1	< 0.1%
15871.956	1	< 0.1%

MBAvg
Real number (ℝ)

HIGH CORRELATION

Distinct	2929
Distinct (%)	75.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-190.0798781

Minimum	-15207.6
Maximum	101.356
Zeros	0
Zeros (%)	0.0%
Negative	425
Negative (%)	10.9%
Memory size	30.6 KiB

Quantile statistics

Minimum	-15207.6
5-th percentile	-567.501
Q1	57.8131
median	84.1748
Q3	92.5596
95-th percentile	97.9745
Maximum	101.356
Range	15308.956
Interquartile range (IQR)	34.7465

Descriptive statistics

Standard deviation	1465.504305
Coefficient of variation (CV)	-7.709939209
Kurtosis	47.18214444
Mean	-190.0798781
Median Absolute Deviation (MAD)	10.8249
Skewness	-6.750908172
Sum	-741501.6045
Variance	2147702.868
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99.728	46	1.2%
95.9801	17	0.4%
97.8591	16	0.4%
99.8187	14	0.4%
94.3415	14	0.4%
89.1793	13	0.3%
91.6726	13	0.3%
89.6054	13	0.3%
83.0614	12	0.3%
90.9795	11	0.3%
Other values (2919)	3732	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-15207.6	1	< 0.1%
-15086.2	1	< 0.1%
-15079.9	1	< 0.1%
-12186	3	0.1%
-12185.8	1	< 0.1%
-12185.7	2	0.1%
-11796.1	2	0.1%
-11791.7	6	0.2%
-11791.6	2	0.1%
-11606.5	1	< 0.1%

Value	Count	Frequency (%)
101.356	5	0.1%
99.9322	1	< 0.1%
99.907	1	< 0.1%
99.8897	1	< 0.1%
99.8187	14	0.4%
99.7939	2	0.1%
99.7711	1	< 0.1%
99.7655	1	< 0.1%
99.728	46	1.2%
99.5738	2	0.1%

MBMax
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	17
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.76468905

Minimum	66.3043
Maximum	103.256
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	66.3043
5-th percentile	99.456
Q1	99.456
median	100
Q3	100
95-th percentile	100.103
Maximum	103.256
Range	36.9517
Interquartile range (IQR)	0.544

Descriptive statistics

Standard deviation	0.6855645268
Coefficient of variation (CV)	0.006871815401
Kurtosis	1509.1123
Mean	99.76468905
Median Absolute Deviation (MAD)	0.103
Skewness	-32.60607807
Sum	389182.052
Variance	0.4699987203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
99.456	1683	43.1%
100	1628	41.7%
100.103	505	12.9%
99.9127	33	0.8%
99.8721	13	0.3%
99.5711	11	0.3%
103.256	7	0.2%
99.6007	5	0.1%
99.9275	4	0.1%
99.9859	3	0.1%
Other values (7)	9	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
66.3043	1	< 0.1%
87.1146	1	< 0.1%
87.8249	1	< 0.1%
96.0351	1	< 0.1%
98.5838	1	< 0.1%
99.4536	2	0.1%
99.456	1683	43.1%
99.5711	11	0.3%
99.6007	5	0.1%
99.8087	2	0.1%

Value	Count	Frequency (%)
103.256	7	0.2%
100.103	505	12.9%
100	1628	41.7%
99.9859	3	0.1%
99.9275	4	0.1%
99.9127	33	0.8%
99.8721	13	0.3%
99.8087	2	0.1%
99.6007	5	0.1%
99.5711	11	0.3%

MBMin
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	598
Distinct (%)	15.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1861.663046

Minimum	-45434.1
Maximum	99.5711
Zeros	170
Zeros (%)	4.4%
Negative	1493
Negative (%)	38.3%
Memory size	30.6 KiB

Quantile statistics

Minimum	-45434.1
5-th percentile	-9667.18
Q1	-111.962
median	41.583
Q3	79.2665
95-th percentile	96.0451
Maximum	99.5711
Range	45533.6711
Interquartile range (IQR)	191.2285

Descriptive statistics

Standard deviation	7828.047807
Coefficient of variation (CV)	-4.204868235
Kurtosis	23.97687916
Mean	-1861.663046
Median Absolute Deviation (MAD)	46.9013
Skewness	-4.938765407
Sum	-7262347.544
Variance	61278332.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-111.962	252	6.5%
0	170	4.4%
-45434.1	108	2.8%
88.4843	95	2.4%
-365.335	88	2.3%
-16.5	77	2.0%
99.456	73	1.9%
-17816.7	62	1.6%
-9667.18	58	1.5%
-1206.01	52	1.3%
Other values (588)	2866	73.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-45434.1	108	2.8%
-30917.7	1	< 0.1%
-17816.7	62	1.6%
-14638.7	7	0.2%
-10057.1	4	0.1%
-9667.18	58	1.5%
-8683.11	2	0.1%
-8412.82	4	0.1%
-4519.05	2	0.1%
-4440.64	1	< 0.1%

Value	Count	Frequency (%)
99.5711	1	< 0.1%
99.456	73	1.9%
99.4536	1	< 0.1%
99.3717	1	< 0.1%
99.2771	3	0.1%
99.2466	8	0.2%
99.2243	1	< 0.1%
99.1477	7	0.2%
98.9339	18	0.5%
98.7526	5	0.1%

NArticulos
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	571
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.00517047

Minimum	1
Maximum	8443
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	6
Q3	24
95-th percentile	251.5
Maximum	8443
Range	8442
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	315.207344
Coefficient of variation (CV)	4.924716889
Kurtosis	340.8852706
Mean	64.00517047
Median Absolute Deviation (MAD)	4
Skewness	15.82156944
Sum	249684.17
Variance	99355.66969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	619	15.9%
3	380	9.7%
4	375	9.6%
5	375	9.6%
6	210	5.4%
7	150	3.8%
9	104	2.7%
8	104	2.7%
10	88	2.3%
11	52	1.3%
Other values (561)	1444	37.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	619	15.9%
3	380	9.7%
4	375	9.6%
5	375	9.6%
6	210	5.4%
6.25	1	< 0.1%
7	150	3.8%
7.375	1	< 0.1%
8	104	2.7%

Value	Count	Frequency (%)
8443	1	< 0.1%
8187.5	1	< 0.1%
7173.125	1	< 0.1%
4748.625	1	< 0.1%
3836	1	< 0.1%
3414	1	< 0.1%
3174.5	1	< 0.1%
3002.5	1	< 0.1%
2964.5	1	< 0.1%
2879.5	1	< 0.1%

NContratos
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	218
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.37605742

Minimum	1
Maximum	1538
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	6
Q3	13
95-th percentile	84
Maximum	1538
Range	1537
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	70.44508922
Coefficient of variation (CV)	3.29551366
Kurtosis	186.5875972
Mean	21.37605742
Median Absolute Deviation (MAD)	3
Skewness	11.46698484
Sum	83388
Variance	4962.510596
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	663	17.0%
3	427	10.9%
4	416	10.7%
5	395	10.1%
6	303	7.8%
7	168	4.3%
9	138	3.5%
8	130	3.3%
10	115	2.9%
11	75	1.9%
Other values (208)	1071	27.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	663	17.0%
3	427	10.9%
4	416	10.7%
5	395	10.1%
6	303	7.8%
7	168	4.3%
8	130	3.3%
9	138	3.5%
10	115	2.9%

Value	Count	Frequency (%)
1538	2	0.1%
1374	1	< 0.1%
988	1	< 0.1%
984	1	< 0.1%
947	1	< 0.1%
763	1	< 0.1%
750	1	< 0.1%
698	1	< 0.1%
576	1	< 0.1%
574	1	< 0.1%

PrecMedArticulo
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	2351
Distinct (%)	60.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.3535253

Minimum	-24
Maximum	1211
Zeros	52
Zeros (%)	1.3%
Negative	4
Negative (%)	0.1%
Memory size	30.6 KiB

Quantile statistics

Minimum	-24
5-th percentile	2.422
Q1	8.8375
median	14.39
Q3	25.702916
95-th percentile	49.32
Maximum	1211
Range	1235
Interquartile range (IQR)	16.865416

Descriptive statistics

Standard deviation	30.26522307
Coefficient of variation (CV)	1.486976955
Kurtosis	671.801925
Mean	20.3535253
Median Absolute Deviation (MAD)	7.182027
Skewness	19.92168487
Sum	79399.1022
Variance	915.9837274
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.06	79	2.0%
20.2	78	2.0%
9.763333	62	1.6%
10.1	59	1.5%
9.09	59	1.5%
8.08	53	1.4%
0	52	1.3%
7.07	51	1.3%
15.15	50	1.3%
12.625	49	1.3%
Other values (2341)	3309	84.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-24	1	< 0.1%
-22.649316	1	< 0.1%
-14.879257	1	< 0.1%
-1.068461	1	< 0.1%
0	52	1.3%
0.0101	1	< 0.1%
0.02875	1	< 0.1%
0.104	1	< 0.1%
0.159	1	< 0.1%
0.159555	1	< 0.1%

Value	Count	Frequency (%)
1211	1	< 0.1%
624.015789	1	< 0.1%
371.804	1	< 0.1%
331.28125	1	< 0.1%
319.263333	1	< 0.1%
290.682203	1	< 0.1%
290.4	1	< 0.1%
277.373333	1	< 0.1%
260.06	1	< 0.1%
241.747619	1	< 0.1%

DifCPrevCReal
Real number (ℝ)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	181
Distinct (%)	9.3%
Missing	1951
Missing (%)	50.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.49076923

Minimum	-101
Maximum	6908
Zeros	231
Zeros (%)	5.9%
Negative	585
Negative (%)	15.0%
Memory size	30.6 KiB

Quantile statistics

Minimum	-101
5-th percentile	-28
Q1	-3
median	3
Q3	9
95-th percentile	51
Maximum	6908
Range	7009
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	160.1156094
Coefficient of variation (CV)	15.26252326
Kurtosis	1769.534383
Mean	10.49076923
Median Absolute Deviation (MAD)	6
Skewness	41.11657782
Sum	20457
Variance	25637.00838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	231	5.9%
4	113	2.9%
5	96	2.5%
6	91	2.3%
1	76	1.9%
3	75	1.9%
2	68	1.7%
7	68	1.7%
-1	58	1.5%
-3	48	1.2%
Other values (171)	1026	26.3%
(Missing)	1951	50.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-101	1	< 0.1%
-98	1	< 0.1%
-94	1	< 0.1%
-87	1	< 0.1%
-82	1	< 0.1%
-80	1	< 0.1%
-79	1	< 0.1%
-75	1	< 0.1%
-72	3	0.1%
-71	1	< 0.1%

Value	Count	Frequency (%)
6908	1	< 0.1%
577	1	< 0.1%
424	1	< 0.1%
366	1	< 0.1%
357	1	< 0.1%
243	1	< 0.1%
240	1	< 0.1%
210	2	0.1%
203	1	< 0.1%
196	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	Company Name	Address	City	State	Postal Code	Credit Limit Requested	Payment Method Requested Code	Credit Limit Granted	Commercial Risk Cover Protected	Commercial Risk Group Code	Payment Method Granted	Payment Terms Granted	Status Code	Status	Classification Decision Code	Classification Decision	Request Entry Date	Effective Date	Nif	ClientePadre	IDCliente	VENTASCLIENTE	MBAvg	MBMax	MBMin	NArticulos	NContratos	PrecMedArticulo	DifCPrevCReal
0	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	U27869056	8	80002	4088.0932	32.83660	100.0	-1206.0100	692.50	224	15.130683	-3.0
1	1	INDUSTRIAS CANDIDO HERMIDA SL	O CALVARIO S/N	VALDOVIEO	LA CORUÑA	15542.0	45000.0	99.0	0.0	0.0	0.0	0.0	0.0	2.0	ANULADA	58.0	VOLUMEN DE RIESGO ELEVADO	20200318.0	20200217.0	B15057474	11	110007	830.1700	-3.13485	100.0	-816.4920	121.00	121	6.860909	-39.0
2	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	B15399314	12	120003	392.2800	3.70088	100.0	-630.3950	21.50	19	20.356842	7.0
3	3	ESTRUCTURAS DE HORMIGON Y CONSTRUCCIONES ALPA SL	VILLA SOLEDAD 2	EL FERROL	LA CORU A	15404.0	45000.0	99.0	0.0	0.0	0.0	0.0	0.0	2.0	ANULADA	35.0	PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE	20200318.0	20210731.0	B15054109	13	130030	2402.7208	73.62650	100.0	-1206.0100	373.00	165	11.935398	8.0
4	4	HIJOS JOSE LOSADA CANCELO SA	PERBES 35	EL FERROL	LA CORU A	15404.0	45000.0	99.0	45000.0	95.0	1.0	99.0	180.0	66.0	EN VIGOR	23.0	DECISION CESCE	20210420.0	20220402.0	A15056849	14	140010	2044.0675	31.62250	100.0	-816.4920	202.50	94	18.651462	0.0
5	5	CAMUYDE S.L.	CTRA CEDEIRA KM ,	NARON	LA CORUñA	15578.0	45000.0	99.0	0.0	0.0	0.0	0.0	0.0	2.0	ANULADA	65.0	ANULACIÓN POR VENCIMIENTO DE LA VALIDEZ DEL SUPLEMENTO	20201005.0	20220729.0	B15025760	15	150003	295.3400	82.80580	100.0	17.4219	13.00	13	22.718461	7.0
6	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	P1503700E	16	160011	29955.6420	62.08900	100.0	-1076.9800	115.25	103	290.682203	29.0
7	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	P1505500G	17	170004	582.5000	91.34800	100.0	57.1962	155.00	8	11.562500	16.0
8	8	GABADI SL	O ESPIÑO	FERROL	LA CORUÑA	15404.0	45000.0	99.0	20000.0	95.0	3.0	99.0	180.0	66.0	EN VIGOR	30.0	SITUACIÓN FINANCIERA AJUSTADA	20220422.0	20220905.0	B15225055	18	180003	239.8400	92.60940	100.0	78.1147	12.00	12	19.986666	-3.0
9	9	FRANCISCO MATA SA	SAN PEDRO VIESNA LOURE 1	LA CORU A	LA CORU A	15000.0	45000.0	99.0	45000.0	95.0	3.0	99.0	180.0	66.0	EN VIGOR	23.0	DECISION CESCE	20200720.0	20220702.0	A15034101	19	190002	388.8300	25.93890	100.0	-469.7170	24.25	9	39.475555	-3.0

Last rows

	Unnamed: 0	Company Name	Address	City	State	Postal Code	Credit Limit Requested	Payment Method Requested Code	Credit Limit Granted	Commercial Risk Cover Protected	Commercial Risk Group Code	Payment Method Granted	Payment Terms Granted	Status Code	Status	Classification Decision Code	Classification Decision	Request Entry Date	Effective Date	Nif	ClientePadre	IDCliente	VENTASCLIENTE	MBAvg	MBMax	MBMin	NArticulos	NContratos	PrecMedArticulo	DifCPrevCReal
3891	3891	GRABADOS Y CRISTALERIA MONCHO SL	IND. GRELAS-BENS . CL GAMBRINUS , 00	A CORUNA	LA CORUñA	15008.0	45000.0	99.0	45000.0	95.0	5.0	99.0	180.0	66.0	EN VIGOR	35.0	PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE	20220927.0	20220801.0	B15162357	6350	63500002	246.54	-135.5050	100.000	-1076.9800	5.0	5	49.308000	0.0
3892	3892	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32678967S	6352	63520002	44.44	-84.3083	99.456	-352.3810	3.0	3	14.813333	NaN
3893	3893	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33994526C	6353	63530002	28.28	92.7194	100.000	79.2665	4.0	4	7.070000	NaN
3894	3894	CONSTRUGENIA PROYECTOS Y OBRAS S.L	C/MEJICO Nº10-2ºIZQ.	A CORUÑA	LA CORUñA	15009.0	45000.0	99.0	20000.0	95.0	4.0	99.0	180.0	66.0	EN VIGOR	32.0	DIMENSIÓN REDUCIDA	20220929.0	20220801.0	B70157763	6354	63540002	24.24	95.1112	100.000	87.3808	8.0	8	3.030000	NaN
3895	3895	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32669675S	6356	63560002	27.27	96.4697	99.456	91.6705	3.0	3	9.090000	NaN
3896	3896	AGEITOS REGO SERVICIOS DE MANTENIMIENTO SL.	EMILIA PARDO BAZAN, 5 - ENT	RIBEIRA	LA CORUñA	15960.0	45000.0	99.0	15000.0	95.0	5.0	99.0	180.0	66.0	EN VIGOR	32.0	DIMENSIÓN REDUCIDA	20220928.0	20220801.0	B70530118	6359	63590002	10.10	33.1520	99.456	0.0000	3.0	3	3.366666	NaN
3897	3897	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32716859A	6361	63610002	29.29	93.6067	99.456	88.4843	3.0	3	9.763333	NaN
3898	3898	CONTRATAS Y VENTAS SAU	CL ASTURIAS 41	OVIEDO	ASTURIAS	33004.0	45000.0	99.0	45000.0	95.0	0.0	99.0	180.0	66.0	EN VIGOR	0.0	NaN	20220929.0	20220801.0	A33014218	6367	63670002	28.00	62.3104	99.456	-16.5000	8.0	7	4.000000	NaN
3899	3899	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32948867X	6375	63750002	19.19	96.9301	99.456	92.1549	3.0	3	6.396666	NaN
3900	3900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32719041T	6378	63780002	58.58	-3941.1300	99.456	-9667.1800	4.0	4	14.645000	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Lowercase Letter

Space Separator

Dash Punctuation

Modifier Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Open Punctuation

Other Letter

Space Separator

Dash Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks